{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2019年8、9月份，上海静安和杭州西湖均价下跌分析\n",
    "\n",
    "分析之后结论是，区域总成交量较少，而区域内不同小区价格差别较大，高价小区成交变少，低价小区成交较多, 导致均价下跌。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "data/chengjiao-上海/2019-08-02-上海.xls\n",
      "data/chengjiao-上海/2019-08-03-上海.xls\n",
      "data/chengjiao-上海/2019-08-07-上海.xls\n",
      "data/chengjiao-上海/2019-08-09-上海.xls\n",
      "data/chengjiao-上海/2019-08-16-上海.xls\n",
      "data/chengjiao-上海/2019-08-22-上海.xls\n",
      "data/chengjiao-上海/2019-08-30-上海.xls\n",
      "data/chengjiao-上海/2019-09-05-上海.xls\n",
      "data/chengjiao-上海/2019-09-06-上海.xls\n",
      "data/chengjiao-上海/2019-09-07-上海.xls\n",
      "data/chengjiao-上海/2019-09-10-上海.xls\n",
      "data/chengjiao-上海/2019-09-12-上海.xls\n",
      "data/chengjiao-上海/2019-09-14-上海.xls\n",
      "data/chengjiao-上海/2019-09-20-上海.xls\n",
      "data/chengjiao-上海/2019-09-27-上海.xls\n",
      "data/chengjiao-上海/allsh.csv\n",
      "data/chengjiao-上海/chengjiao-2019-07-14-310000.xls\n",
      "data/chengjiao-上海/chengjiao-2019-07-15-310000.xls\n",
      "data/chengjiao-上海/chengjiao-2019-07-15-上海.xls\n",
      "data/chengjiao-上海/chengjiao-2019-07-19-上海.xls\n",
      "data/chengjiao-上海/chengjiao-2019-07-24-上海.xls\n",
      "data/chengjiao-上海/chengjiao-2019-07-26-上海.xls\n",
      "data/chengjiao-上海/chengjiao-2019-07-29-上海.xls\n",
      "data/chengjiao-上海/chengjiao-2019-07-31-上海.xls\n",
      "data/chengjiao-上海/chengjiao-2019-08-01-上海.xls\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/alex/Quant/code/LianjiaSpider/common.py:87: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version\n",
      "of pandas will change to not sort by default.\n",
      "\n",
      "To accept the future behavior, pass 'sort=True'.\n",
      "\n",
      "To retain the current behavior and silence the warning, pass sort=False\n",
      "\n",
      "  df = pd.concat(dfs)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "123541\n",
      "data/chengjiao-杭州/2019-08-02-杭州.xls\n",
      "data/chengjiao-杭州/2019-08-07-杭州.xls\n",
      "data/chengjiao-杭州/2019-08-09-杭州.xls\n",
      "data/chengjiao-杭州/2019-08-16-杭州.xls\n",
      "data/chengjiao-杭州/2019-08-22-杭州.xls\n",
      "data/chengjiao-杭州/2019-08-24-杭州.xls\n",
      "data/chengjiao-杭州/2019-08-30-杭州.xls\n",
      "data/chengjiao-杭州/2019-09-05-杭州.xls\n",
      "data/chengjiao-杭州/2019-09-07-杭州.xls\n",
      "data/chengjiao-杭州/2019-09-09-杭州.xls\n",
      "data/chengjiao-杭州/2019-09-12-杭州.xls\n",
      "data/chengjiao-杭州/2019-09-14-杭州.xls\n",
      "data/chengjiao-杭州/2019-09-20-杭州.xls\n",
      "data/chengjiao-杭州/2019-09-27-杭州.xls\n",
      "data/chengjiao-杭州/allhz.csv\n",
      "27926\n"
     ]
    }
   ],
   "source": [
    "from common import read\n",
    "df_sh = read('上海')\n",
    "df_hz = read('杭州')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df_sh\n",
    "df1 = df[df['下辖区']=='静安']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "73665.14583333333 73092.0\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1170bbd68>"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYQAAAD8CAYAAAB3u9PLAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAEYxJREFUeJzt3X+MZWV9x/H3t6zIj4u7bIHpdiEZaAwJMlXZGyva2BnRiizRtmktZGvAH5mkthTtGruEtLb/oWKjxqY4Gam0UqquWM2qRUKd2CZ21UVkFxdkhVV3pSC1rh1qohu//eM+y96dzp3d++OcO/fyfiWTOfc5597n+c5zdz57zpl7TmQmkiT9wrAHIElaHQwESRJgIEiSCgNBkgQYCJKkwkCQJAEGgiSpMBAkSYCBIEkq1tTZ2VlnnZVnn302p59+ep3d1uqpp54a2/rGuTawvlE2zrUB7Nq168nMPLvqfmoNhMnJSW6++Wamp6fr7LZWCwsLY1vfONcG1jfKxrk2gIj4Th39eMhIkgQYCJKkwkCQJAEGgiSpMBAkScAJBEJE3BoRT0TEnra290TEgxFxf0R8KiLWVTtMSVLVTmQP4SPA5Uva7gYuzsxfBb4F3DDgcUmSanbcQMjMLwE/XNL2hcw8XB7+B3BuBWOTJNVoEOcQ3gh8fgCvI0kaosjM428UMQnsyMyLl7TfCDSB38kOLxQRs8AswMTExKb5+XkajUafw169FhcXO9a3++Chrl5rauPaQQxpYFaqbRxY3+ga59oAZmZmdmVms+p+er50RURcA1wJXNYpDAAycw6YA2g2m9loNMb6I+YrfYT+2m2f7eq19m9Z/nWGZdwvD2B9o2uca6tTT4EQEZcDfwb8Rmb+72CHJEkahhP5s9M7gC8DF0bEgYh4E/BB4Azg7oi4LyJuqXickqSKHXcPITOvXqb5wxWMRZI0RH5SWZIEGAiSpMJAkCQBBoIkqTAQJEmAgSBJKgwESRJgIEiSCgNBkgQYCJKkwkCQJAEGgiSp6Pl+CKreZLf3T7hpc0UjkfRM4B6CJAkwECRJhYEgSQIMBElSYSBIkgADQZJUGAiSJMBAkCQVBoIkCTAQJEmFgSBJAgwESVJhIEiSgBMIhIi4NSKeiIg9bW3rI+LuiHi4fD+z2mFKkqp2InsIHwEuX9K2DbgnM58L3FMeS5JG2HEDITO/BPxwSfNrgdvK8m3Abw14XJKkmkVmHn+jiElgR2ZeXB7/KDPXta3/78xc9rBRRMwCswATExOb5ufnaTQaAxj66rS4uNixvt0HD1Xa99TGtZW+/kq1jQPrG13jXBvAzMzMrsxsVt1P5XdMy8w5YA6g2Wxmo9Fgenq66m6HZmFhoWN913Z5B7Ru7d+yfL+DslJt48D6Rtc411anXv/K6PGI2ABQvj8xuCFJkoah10D4DHBNWb4G+PRghiNJGpYT+bPTO4AvAxdGxIGIeBNwE/DKiHgYeGV5LEkaYcc9h5CZV3dYddmAxyJJGiI/qSxJAgwESVJhIEiSAANBklQYCJIkwECQJBUGgiQJMBAkSYWBIEkCDARJUmEgSJIAA0GSVBgIkiTAQJAkFQaCJAkwECRJhYEgSQIMBElSYSBIkgADQZJUGAiSJMBAkCQVBoIkCTAQJEmFgSBJAvoMhIh4W0Q8EBF7IuKOiDhlUAOTJNWr50CIiI3AnwDNzLwYOAm4alADkyTVq99DRmuAUyNiDXAa8P3+hyRJGoaeAyEzDwI3A98FHgMOZeYXBjUwSVK9IjN7e2LEmcAngd8HfgR8AtiemR9dst0sMAswMTGxaX5+nkaj0degV7PFxcWO9e0+eKjSvqc2rq309VeqbRwsV18vc1b1PPRqnOdvnGsDmJmZ2ZWZzar7WdPHc18BPJqZPwCIiDuBlwDHBEJmzgFzAM1mMxuNBtPT0310u7otLCx0rO/abZ+ttO/9W5bvd1BWqm0cLFdfL3NW9Tz0apznb5xrq1M/5xC+C7w4Ik6LiAAuA/YOZliSpLr1cw5hJ7AduBfYXV5rbkDjkiTVrJ9DRmTmO4F3DmgskqQh8pPKkiTAQJAkFQaCJAkwECRJhYEgSQIMBElSYSBIkgADQZJUGAiSJMBAkCQVBoIkCTAQJElFXxe3k45nsuJ7QHRr/02bhz0EadVyD0GSBBgIkqTCQJAkAQaCJKkwECRJgIEgSSoMBEkSYCBIkgoDQZIEGAiSpMJAkCQBBoIkqTAQJElAn4EQEesiYntEPBgReyPi0kENTJJUr34vf/1+4F8y83cj4mTgtAGMSZI0BD0HQkQ8B3gZcC1AZv4U+OlghiVJqltkZm9PjHgBMAd8E3g+sAu4PjOfWrLdLDALMDExsWl+fp5Go9HXoFezxcXFjvXtPnio0r6nNq7tavtuxzNxKpyzvto+qrbSz2i5uatj/N3OW69Wem+OunGuDWBmZmZXZjar7qefQ0ZrgEuA6zJzZ0S8H9gG/Hn7Rpk5Rys4aDab2Wg0mJ6e7qPb1W1hYaFjfddWfPew/VuW77eTbsezdeowr+ty7qquuVsr/YyWm7s6xt/tvPVqpffmqBvn2urUz0nlA8CBzNxZHm+nFRCSpBHUcyBk5n8C34uIC0vTZbQOH0mSRlC/f2V0HXB7+QujR4A39D8kSdIw9BUImXkfUPmJDklS9fyksiQJMBAkSYWBIEkCDARJUmEgSJIAA0GSVBgIkiTAQJAkFQaCJAkwECRJhYEgSQIMBElS0e/VTqWRMrnCDW+2Th0eyg19VhrTcvbftLmikeiZzj0ESRJgIEiSCgNBkgQYCJKkwkCQJAEGgiSpMBAkSYCBIEkqDARJEmAgSJIKA0GSBBgIkqSi70CIiJMi4usRsWMQA5IkDccg9hCuB/YO4HUkSUPUVyBExLnAZmB+MMORJA1Lv3sI7wPeAfx8AGORJA1RZGZvT4y4ErgiM98SEdPA2zPzymW2mwVmASYmJjbNz8/TaDT6GPLqtri42LG+3QcPVdr31Ma1XW3f7XgmToVz1lfbxzBNnAqP/2TYozi+buf5iJXem+26nbNexzNIJ1rbqJqZmdmVmc2q++nnjmkvBV4TEVcApwDPiYiPZuYftG+UmXPAHECz2cxGo8H09HQf3a5uCwsLHeur+m5c+7cs328n3Y5n69RhXtfl3A3jDmS92jp1mPfuXv03Eex2no9Y6b3Zrts563U8g3SitWllPR8yyswbMvPczJwErgL+dWkYSJJGh59DkCQB/R0yelpmLgALg3gtSdJwuIcgSQIMBElSYSBIkgADQZJUGAiSJMBAkCQVBoIkCTAQJEmFgSBJAgwESVJhIEiSAANBklSs/ou/S+rLZLm/wdapw6vm/hSTAx7H0tr237R5oK//TOEegiQJMBAkSYWBIEkCDARJUmEgSJIAA0GSVBgIkiTAQJAkFQaCJAkwECRJhYEgSQIMBElSYSBIkoA+AiEizouIL0bE3oh4ICKuH+TAJEn16ufy14eBrZl5b0ScAeyKiLsz85sDGpskqUY97yFk5mOZeW9Z/h9gL7BxUAOTJNUrMrP/F4mYBL4EXJyZP16ybhaYBZiYmNg0Pz9Po9Hou8/VanFxsWN9uw8eqrTvqY1ru9q+2/FMnArnrK+2j2GaOBUe/8mwR1Gdqurr9n0Hg39fLK2tlzGtZjMzM7sys1l1P33fMS0iGsAngbcuDQOAzJwD5gCazWY2Gg2mp6f77XbVWlhY6Fhf1Xer2r9l+X476XY8W6cO87ou52613KHrRGydOsx7d4/vTQSrqq/b9x0M/n2xtLZexqQ+/8ooIp5FKwxuz8w7BzMkSdIw9PNXRgF8GNibmX89uCFJkoahnz2ElwKvB14eEfeVrysGNC5JUs16PqCYmf8OxADHIkkaIj+pLEkCDARJUmEgSJIAA0GSVBgIkiTAQJAkFQaCJAkwECRJhYEgSQIMBElSYSBIkgADQZJUjMzdQCa7vKHG/ps2V97HcrZOHR7aTWEGMf7V0IdGyzPxPdFLzb38TqqbewiSJMBAkCQVBoIkCTAQJEmFgSBJAgwESVJhIEiSAANBklQYCJIkwECQJBUGgiQJMBAkSUVfgRARl0fEQxGxLyK2DWpQkqT69RwIEXES8DfAq4GLgKsj4qJBDUySVK9+9hBeBOzLzEcy86fAPwGvHcywJEl16ycQNgLfa3t8oLRJkkZQZGZvT4z4PeBVmfnm8vj1wIsy87ol280Cs+XhhcB/AU/2POLV7yzGt75xrg2sb5SNc20AF2bmGVV30s8d0w4A57U9Phf4/tKNMnMOmDvyOCK+lpnNPvpd1ca5vnGuDaxvlI1zbdCqr45++jlk9FXguRFxfkScDFwFfGYww5Ik1a3nPYTMPBwRfwzcBZwE3JqZDwxsZJKkWvVzyIjM/BzwuS6fNnf8TUbaONc3zrWB9Y2yca4Naqqv55PKkqTx4qUrJElAj4EQEedFxBcjYm9EPBAR15f29RFxd0Q8XL6fWdojIj5QLnFxf0Rc0vZa15TtH46Ia9raN0XE7vKcD0RE9FtsD3WeFBFfj4gd5fH5EbGzjPVj5WQ6EfHs8nhfWT/Z9ho3lPaHIuJVbe1Du+xHRKyLiO0R8WCZw0vHae4i4m3lfbknIu6IiFNGee4i4taIeCIi9rS1VT5fnfqoqb73lPfn/RHxqYhY17auq3npZe6rrK1t3dsjIiPirPJ4+HOXmV1/ARuAS8ryGcC3aF2+4t3AttK+DXhXWb4C+DwQwIuBnaV9PfBI+X5mWT6zrPsKcGl5zueBV/cy1n6+gD8F/hHYUR5/HLiqLN8C/GFZfgtwS1m+CvhYWb4I+AbwbOB84Nu0TsCfVJYvAE4u21xUY123AW8uyycD68Zl7mh9OPJR4NS2Obt2lOcOeBlwCbCnra3y+erUR031/Sawpiy/q62+ruel27mvurbSfh6tP8j5DnDWapm7QRX9aeCVwEPAhtK2AXioLH8IuLpt+4fK+quBD7W1f6i0bQAebGs/Zrs6vmh9ruIe4OXAjvIDf7LtTXopcFdZvgu4tCyvKdsFcANwQ9tr3lWe9/RzS/sx21Vc13No/cKMJe1jMXcc/QT9+jIXO4BXjfrcAZMc+wuz8vnq1Ecd9S1Z99vA7cv9vI83L738u62jNmA78HxgP0cDYehz1/c5hLKb9UJgJzCRmY8BlO/nlM06XeZipfYDy7TX6X3AO4Cfl8e/CPwoMw8vM6an6yjrD5Xtu627DhcAPwD+LlqHw+Yj4nTGZO4y8yBwM/Bd4DFac7GL8Zi7dnXMV6c+6vZGWv/7he7r6+XfbaUi4jXAwcz8xpJVQ5+7fi9/3QA+Cbw1M3+80qbLtGUP7bWIiCuBJzJzV3vzMpvmcdatxvrW0NqF/dvMfCHwFK1dyk5GqTbKsdLX0jqc8MvA6bSuyNtpTCNV3wkYq3oi4kbgMHD7kaZlNuu1vtprj4jTgBuBv1hudYfx1DZ3/Vz++lm0wuD2zLyzND8eERvK+g3AE6W902UuVmo/d5n2urwUeE1E7Kd1FdeX09pjWBcRRz670T6mp+so69cCP6T7uutwADiQmTvL4+20AmJc5u4VwKOZ+YPM/BlwJ/ASxmPu2tUxX536qEU5eXolsCXLsQ+6r+9Jup/7Kv0Krf+sfKP8fjkXuDcifmmFGuqbux6PiQXw98D7lrS/h2NPZLy7LG/m2JMlXynt62kdzz6zfD0KrC/rvlq2PXKy5Iqqjl8ep9Zpjp5U/gTHnpx6S1n+I449OfXxsvw8jj0B9gitk19ryvL5HD0B9rwaa/o3WhfLAvjLMm9jMXfArwEPAKeV/m8Drhv1ueP/n0OofL469VFTfZcD3wTOXrJd1/PS7dxXXduSdfs5eg5h6HPXa4G/TmvX5H7gvvJ1Ba3jb/cAD5fvRwYdtG6m821gN9Bse603AvvK1xva2pvAnvKcD1LByZ4TrHWao4FwAa2z+vvKm+zZpf2U8nhfWX9B2/NvLDU8RNtf25Sf17fKuhtrrukFwNfK/P1zeZONzdwBfwU8WMbwD7R+eYzs3AF30Dof8jNa/yt8Ux3z1amPmurbR+u4+ZHfL7f0Oi+9zH2VtS1Zv5+jgTD0ufOTypIkwE8qS5IKA0GSBBgIkqTCQJAkAQaCJKkwECRJgIEgSSoMBEkSAP8HRCsY3OyYivoAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "pd.options.display.max_columns = None\n",
    "df1 = df1.loc[df1['成交时间']>'2019-08-01'].sort_values('成交价(元/平)')\n",
    "print(df1['成交价(元/平)'].mean(), df1['成交价(元/平)'].median())\n",
    "df1['成交价(元/平)'].hist(bins = 25)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>上次交易时间</th>\n",
       "      <th>下辖区</th>\n",
       "      <th>交易权属</th>\n",
       "      <th>产权所属</th>\n",
       "      <th>供暖方式</th>\n",
       "      <th>关注（人）</th>\n",
       "      <th>售价(万)</th>\n",
       "      <th>商圈</th>\n",
       "      <th>土地年限</th>\n",
       "      <th>城市</th>\n",
       "      <th>套内面积</th>\n",
       "      <th>小区</th>\n",
       "      <th>带看（次）</th>\n",
       "      <th>建成时间</th>\n",
       "      <th>建筑类型</th>\n",
       "      <th>建筑结构</th>\n",
       "      <th>建筑面积</th>\n",
       "      <th>成交价(元/平)</th>\n",
       "      <th>成交周期(天)</th>\n",
       "      <th>成交时间</th>\n",
       "      <th>户型</th>\n",
       "      <th>户型结构</th>\n",
       "      <th>房屋年限</th>\n",
       "      <th>房屋用途</th>\n",
       "      <th>所在楼层</th>\n",
       "      <th>所属环线</th>\n",
       "      <th>挂牌价格(万)</th>\n",
       "      <th>挂牌时间</th>\n",
       "      <th>朝向</th>\n",
       "      <th>来源</th>\n",
       "      <th>标题</th>\n",
       "      <th>梯户比例</th>\n",
       "      <th>楼型</th>\n",
       "      <th>浏览（次）</th>\n",
       "      <th>状态</th>\n",
       "      <th>电梯</th>\n",
       "      <th>网址</th>\n",
       "      <th>装修</th>\n",
       "      <th>调价(次)</th>\n",
       "      <th>链家编号</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>非共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>77.0</td>\n",
       "      <td>南京西路</td>\n",
       "      <td>70年</td>\n",
       "      <td>上海</td>\n",
       "      <td>30.72㎡</td>\n",
       "      <td>中凯城市之光(静安)</td>\n",
       "      <td>6.0</td>\n",
       "      <td>未知</td>\n",
       "      <td>板楼</td>\n",
       "      <td>钢混结构</td>\n",
       "      <td>30.72</td>\n",
       "      <td>25066.0</td>\n",
       "      <td>162</td>\n",
       "      <td>2019-09-10</td>\n",
       "      <td>1室0厅0厨0卫</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>地下室(共50层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80</td>\n",
       "      <td>2019-04-02</td>\n",
       "      <td>南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>中凯城市之光(静安) 1室0厅 30.72平米</td>\n",
       "      <td>一梯五户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>149</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101180471....</td>\n",
       "      <td>其他</td>\n",
       "      <td>1.0</td>\n",
       "      <td>107101180471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>非共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>彭浦</td>\n",
       "      <td>70年</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>康平小区</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1987</td>\n",
       "      <td>板楼</td>\n",
       "      <td>钢混结构</td>\n",
       "      <td>47.49</td>\n",
       "      <td>37903.0</td>\n",
       "      <td>30</td>\n",
       "      <td>2019-09-02</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>平层</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>低楼层(共14层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>188</td>\n",
       "      <td>2019-08-03</td>\n",
       "      <td>西北</td>\n",
       "      <td>NaN</td>\n",
       "      <td>康平小区 1室1厅 47.49平米</td>\n",
       "      <td>一梯五户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>785</td>\n",
       "      <td>NaN</td>\n",
       "      <td>有</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101602927....</td>\n",
       "      <td>简装</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107101602927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.0</td>\n",
       "      <td>187.0</td>\n",
       "      <td>阳城</td>\n",
       "      <td>未知</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>万荣小区</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1996</td>\n",
       "      <td>板楼</td>\n",
       "      <td>砖混结构</td>\n",
       "      <td>44.00</td>\n",
       "      <td>42500.0</td>\n",
       "      <td>58</td>\n",
       "      <td>2019-09-07</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>平层</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>高楼层(共6层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>195</td>\n",
       "      <td>2019-07-11</td>\n",
       "      <td>南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>万荣小区 1室1厅 44平米</td>\n",
       "      <td>一梯四户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1345</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101525418....</td>\n",
       "      <td>精装</td>\n",
       "      <td>1.0</td>\n",
       "      <td>107101525418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>非共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>63.0</td>\n",
       "      <td>215.0</td>\n",
       "      <td>彭浦</td>\n",
       "      <td>未知</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>彭新小区</td>\n",
       "      <td>82.0</td>\n",
       "      <td>1985</td>\n",
       "      <td>板楼</td>\n",
       "      <td>砖混结构</td>\n",
       "      <td>50.24</td>\n",
       "      <td>42795.0</td>\n",
       "      <td>109</td>\n",
       "      <td>2019-09-02</td>\n",
       "      <td>2室0厅1厨1卫</td>\n",
       "      <td>平层</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>高楼层(共6层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>220</td>\n",
       "      <td>2019-05-17</td>\n",
       "      <td>南 北</td>\n",
       "      <td>NaN</td>\n",
       "      <td>彭新小区 2室0厅 50.24平米</td>\n",
       "      <td>一梯四户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3471</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101328353....</td>\n",
       "      <td>毛坯</td>\n",
       "      <td>1.0</td>\n",
       "      <td>107101328353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>彭浦</td>\n",
       "      <td>70年</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>阳曲路75弄</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1990</td>\n",
       "      <td>板楼</td>\n",
       "      <td>砖混结构</td>\n",
       "      <td>41.77</td>\n",
       "      <td>43094.0</td>\n",
       "      <td>197</td>\n",
       "      <td>2019-09-02</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>平层</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>高楼层(共6层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>186</td>\n",
       "      <td>2019-02-17</td>\n",
       "      <td>南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>阳曲路75弄 1室1厅 41.77平米</td>\n",
       "      <td>一梯四户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3321</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101024782....</td>\n",
       "      <td>简装</td>\n",
       "      <td>1.0</td>\n",
       "      <td>107101024782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.0</td>\n",
       "      <td>228.0</td>\n",
       "      <td>彭浦</td>\n",
       "      <td>未知</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>岭南路270弄</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1984</td>\n",
       "      <td>板楼</td>\n",
       "      <td>砖混结构</td>\n",
       "      <td>52.39</td>\n",
       "      <td>43520.0</td>\n",
       "      <td>330</td>\n",
       "      <td>2019-09-04</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>平层</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>中楼层(共6层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>230</td>\n",
       "      <td>2018-10-10</td>\n",
       "      <td>南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>岭南路270弄 1室1厅 52.39平米</td>\n",
       "      <td>一梯三户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3462</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107100709331....</td>\n",
       "      <td>简装</td>\n",
       "      <td>1.0</td>\n",
       "      <td>107100709331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>非共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>63.0</td>\n",
       "      <td>673.0</td>\n",
       "      <td>江宁路</td>\n",
       "      <td>70年</td>\n",
       "      <td>上海</td>\n",
       "      <td>152㎡</td>\n",
       "      <td>内外联公寓</td>\n",
       "      <td>37.0</td>\n",
       "      <td>1999</td>\n",
       "      <td>板楼</td>\n",
       "      <td>钢混结构</td>\n",
       "      <td>152.00</td>\n",
       "      <td>44277.0</td>\n",
       "      <td>699</td>\n",
       "      <td>2019-08-15</td>\n",
       "      <td>3室2厅1厨2卫</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>高楼层(共20层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>690</td>\n",
       "      <td>2017-09-15</td>\n",
       "      <td>南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>内外联公寓 3室2厅 152平米</td>\n",
       "      <td>两梯八户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1313</td>\n",
       "      <td>NaN</td>\n",
       "      <td>有</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107002175707....</td>\n",
       "      <td>简装</td>\n",
       "      <td>1.0</td>\n",
       "      <td>107002175707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>52.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>彭浦</td>\n",
       "      <td>未知</td>\n",
       "      <td>上海</td>\n",
       "      <td>67.26㎡</td>\n",
       "      <td>星城花苑</td>\n",
       "      <td>54.0</td>\n",
       "      <td>1994</td>\n",
       "      <td>塔楼</td>\n",
       "      <td>钢混结构</td>\n",
       "      <td>67.26</td>\n",
       "      <td>44604.0</td>\n",
       "      <td>129</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>2室1厅1厨1卫</td>\n",
       "      <td>平层</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>低楼层(共13层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>315</td>\n",
       "      <td>2019-04-25</td>\n",
       "      <td>南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>星城花苑 2室1厅 67.26平米</td>\n",
       "      <td>两梯八户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3218</td>\n",
       "      <td>NaN</td>\n",
       "      <td>有</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101256568....</td>\n",
       "      <td>简装</td>\n",
       "      <td>1.0</td>\n",
       "      <td>107101256568</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>非共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>彭浦</td>\n",
       "      <td>未知</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>场中路2401弄</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1985</td>\n",
       "      <td>板楼</td>\n",
       "      <td>砖混结构</td>\n",
       "      <td>37.80</td>\n",
       "      <td>45159.0</td>\n",
       "      <td>83</td>\n",
       "      <td>2019-09-07</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>平层</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>高楼层(共6层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>172</td>\n",
       "      <td>2019-06-17</td>\n",
       "      <td>南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>场中路2401弄 1室1厅 37.8平米</td>\n",
       "      <td>一梯四户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1406</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101438976....</td>\n",
       "      <td>简装</td>\n",
       "      <td>1.0</td>\n",
       "      <td>107101438976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>310.0</td>\n",
       "      <td>不夜城</td>\n",
       "      <td>70年</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>中海万锦城(四期)</td>\n",
       "      <td>7.0</td>\n",
       "      <td>未知</td>\n",
       "      <td>板楼</td>\n",
       "      <td>钢混结构</td>\n",
       "      <td>68.17</td>\n",
       "      <td>45475.0</td>\n",
       "      <td>35</td>\n",
       "      <td>2019-09-09</td>\n",
       "      <td>1室2厅1厨1卫</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>商业办公类</td>\n",
       "      <td>低楼层(共19层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>382</td>\n",
       "      <td>2019-08-05</td>\n",
       "      <td>东 东南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>中海万锦城(四期) 1室2厅 68.17平米</td>\n",
       "      <td>四梯十八户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>929</td>\n",
       "      <td>NaN</td>\n",
       "      <td>有</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101612401....</td>\n",
       "      <td>简装</td>\n",
       "      <td>1.0</td>\n",
       "      <td>107101612401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>非共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.0</td>\n",
       "      <td>305.0</td>\n",
       "      <td>彭浦</td>\n",
       "      <td>未知</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>保德公寓</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1998</td>\n",
       "      <td>板楼</td>\n",
       "      <td>砖混结构</td>\n",
       "      <td>66.80</td>\n",
       "      <td>45659.0</td>\n",
       "      <td>188</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>2室1厅1厨1卫</td>\n",
       "      <td>平层</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>高楼层(共6层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>315</td>\n",
       "      <td>2019-02-25</td>\n",
       "      <td>南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>保德公寓 2室1厅 66.8平米</td>\n",
       "      <td>一梯三户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3736</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101054821....</td>\n",
       "      <td>精装</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107101054821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>非共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>彭浦</td>\n",
       "      <td>未知</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>彭新小区</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1984</td>\n",
       "      <td>板楼</td>\n",
       "      <td>砖混结构</td>\n",
       "      <td>32.60</td>\n",
       "      <td>45706.0</td>\n",
       "      <td>8</td>\n",
       "      <td>2019-09-01</td>\n",
       "      <td>1室0厅0厨1卫</td>\n",
       "      <td>平层</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>高楼层(共6层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>152</td>\n",
       "      <td>2019-08-25</td>\n",
       "      <td>南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>彭新小区 1室0厅 32.6平米</td>\n",
       "      <td>一梯四户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>319</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101681031....</td>\n",
       "      <td>简装</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107101681031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>彭浦</td>\n",
       "      <td>70年</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>恒安小区</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1987</td>\n",
       "      <td>板楼</td>\n",
       "      <td>砖混结构</td>\n",
       "      <td>43.75</td>\n",
       "      <td>45715.0</td>\n",
       "      <td>25</td>\n",
       "      <td>2019-09-08</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>中楼层(共6层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>205</td>\n",
       "      <td>2019-08-15</td>\n",
       "      <td>南 北</td>\n",
       "      <td>NaN</td>\n",
       "      <td>恒安小区 1室1厅 43.75平米</td>\n",
       "      <td>一梯三户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>421</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101643730....</td>\n",
       "      <td>简装</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107101643730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>彭浦</td>\n",
       "      <td>未知</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>银都一村</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1995</td>\n",
       "      <td>板楼</td>\n",
       "      <td>砖混结构</td>\n",
       "      <td>37.47</td>\n",
       "      <td>45904.0</td>\n",
       "      <td>34</td>\n",
       "      <td>2019-09-06</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>平层</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>中楼层(共6层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>176</td>\n",
       "      <td>2019-08-03</td>\n",
       "      <td>南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>银都一村 1室1厅 37.47平米</td>\n",
       "      <td>一梯四户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1125</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101604638....</td>\n",
       "      <td>精装</td>\n",
       "      <td>1.0</td>\n",
       "      <td>107101604638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>NaN</td>\n",
       "      <td>静安</td>\n",
       "      <td>商品房</td>\n",
       "      <td>共有</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>239.0</td>\n",
       "      <td>彭浦</td>\n",
       "      <td>未知</td>\n",
       "      <td>上海</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>康泉小区</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1995</td>\n",
       "      <td>板楼</td>\n",
       "      <td>砖混结构</td>\n",
       "      <td>51.07</td>\n",
       "      <td>46799.0</td>\n",
       "      <td>12</td>\n",
       "      <td>2019-08-31</td>\n",
       "      <td>2室1厅1厨1卫</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>暂无数据</td>\n",
       "      <td>普通住宅</td>\n",
       "      <td>中楼层(共6层)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>248</td>\n",
       "      <td>2019-08-20</td>\n",
       "      <td>西南</td>\n",
       "      <td>NaN</td>\n",
       "      <td>康泉小区 2室1厅 51.07平米</td>\n",
       "      <td>一梯四户</td>\n",
       "      <td>NaN</td>\n",
       "      <td>460</td>\n",
       "      <td>NaN</td>\n",
       "      <td>无</td>\n",
       "      <td>https://sh.lianjia.com/chengjiao/107101663637....</td>\n",
       "      <td>精装</td>\n",
       "      <td>1.0</td>\n",
       "      <td>107101663637</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     上次交易时间 下辖区 交易权属 产权所属 供暖方式  关注（人）  售价(万)    商圈 土地年限  城市    套内面积  \\\n",
       "NaN     NaN  静安  商品房  非共有  NaN    3.0   77.0  南京西路  70年  上海  30.72㎡   \n",
       "NaN     NaN  静安  商品房  非共有  NaN   27.0  180.0    彭浦  70年  上海    暂无数据   \n",
       "NaN     NaN  静安  商品房   共有  NaN   25.0  187.0    阳城   未知  上海    暂无数据   \n",
       "NaN     NaN  静安  商品房  非共有  NaN   63.0  215.0    彭浦   未知  上海    暂无数据   \n",
       "NaN     NaN  静安  商品房   共有  NaN   29.0  180.0    彭浦  70年  上海    暂无数据   \n",
       "NaN     NaN  静安  商品房   共有  NaN   37.0  228.0    彭浦   未知  上海    暂无数据   \n",
       "NaN     NaN  静安  商品房  非共有  NaN   63.0  673.0   江宁路  70年  上海    152㎡   \n",
       "NaN     NaN  静安  商品房   共有  NaN   52.0  300.0    彭浦   未知  上海  67.26㎡   \n",
       "NaN     NaN  静安  商品房  非共有  NaN   14.0  171.0    彭浦   未知  上海    暂无数据   \n",
       "NaN     NaN  静安  商品房   共有  NaN    3.0  310.0   不夜城  70年  上海    暂无数据   \n",
       "NaN     NaN  静安  商品房  非共有  NaN   45.0  305.0    彭浦   未知  上海    暂无数据   \n",
       "NaN     NaN  静安  商品房  非共有  NaN    7.0  149.0    彭浦   未知  上海    暂无数据   \n",
       "NaN     NaN  静安  商品房   共有  NaN    3.0  200.0    彭浦  70年  上海    暂无数据   \n",
       "NaN     NaN  静安  商品房   共有  NaN   13.0  172.0    彭浦   未知  上海    暂无数据   \n",
       "NaN     NaN  静安  商品房   共有  NaN    8.0  239.0    彭浦   未知  上海    暂无数据   \n",
       "\n",
       "             小区  带看（次）  建成时间 建筑类型  建筑结构    建筑面积  成交价(元/平) 成交周期(天)        成交时间  \\\n",
       "NaN  中凯城市之光(静安)    6.0    未知   板楼  钢混结构   30.72   25066.0     162  2019-09-10   \n",
       "NaN        康平小区   19.0  1987   板楼  钢混结构   47.49   37903.0      30  2019-09-02   \n",
       "NaN        万荣小区   15.0  1996   板楼  砖混结构   44.00   42500.0      58  2019-09-07   \n",
       "NaN        彭新小区   82.0  1985   板楼  砖混结构   50.24   42795.0     109  2019-09-02   \n",
       "NaN      阳曲路75弄   26.0  1990   板楼  砖混结构   41.77   43094.0     197  2019-09-02   \n",
       "NaN     岭南路270弄   10.0  1984   板楼  砖混结构   52.39   43520.0     330  2019-09-04   \n",
       "NaN       内外联公寓   37.0  1999   板楼  钢混结构  152.00   44277.0     699  2019-08-15   \n",
       "NaN        星城花苑   54.0  1994   塔楼  钢混结构   67.26   44604.0     129  2019-09-01   \n",
       "NaN    场中路2401弄    7.0  1985   板楼  砖混结构   37.80   45159.0      83  2019-09-07   \n",
       "NaN   中海万锦城(四期)    7.0    未知   板楼  钢混结构   68.17   45475.0      35  2019-09-09   \n",
       "NaN        保德公寓   11.0  1998   板楼  砖混结构   66.80   45659.0     188  2019-09-01   \n",
       "NaN        彭新小区    1.0  1984   板楼  砖混结构   32.60   45706.0       8  2019-09-01   \n",
       "NaN        恒安小区    7.0  1987   板楼  砖混结构   43.75   45715.0      25  2019-09-08   \n",
       "NaN        银都一村   13.0  1995   板楼  砖混结构   37.47   45904.0      34  2019-09-06   \n",
       "NaN        康泉小区    2.0  1995   板楼  砖混结构   51.07   46799.0      12  2019-08-31   \n",
       "\n",
       "           户型  户型结构  房屋年限   房屋用途       所在楼层  所属环线 挂牌价格(万)        挂牌时间    朝向  \\\n",
       "NaN  1室0厅0厨0卫  暂无数据  暂无数据   普通住宅  地下室(共50层)   NaN      80  2019-04-02     南   \n",
       "NaN  1室1厅1厨1卫    平层  暂无数据   普通住宅  低楼层(共14层)   NaN     188  2019-08-03    西北   \n",
       "NaN  1室1厅1厨1卫    平层  暂无数据   普通住宅   高楼层(共6层)   NaN     195  2019-07-11     南   \n",
       "NaN  2室0厅1厨1卫    平层  暂无数据   普通住宅   高楼层(共6层)   NaN     220  2019-05-17   南 北   \n",
       "NaN  1室1厅1厨1卫    平层  暂无数据   普通住宅   高楼层(共6层)   NaN     186  2019-02-17     南   \n",
       "NaN  1室1厅1厨1卫    平层  暂无数据   普通住宅   中楼层(共6层)   NaN     230  2018-10-10     南   \n",
       "NaN  3室2厅1厨2卫  暂无数据  暂无数据   普通住宅  高楼层(共20层)   NaN     690  2017-09-15     南   \n",
       "NaN  2室1厅1厨1卫    平层  暂无数据   普通住宅  低楼层(共13层)   NaN     315  2019-04-25     南   \n",
       "NaN  1室1厅1厨1卫    平层  暂无数据   普通住宅   高楼层(共6层)   NaN     172  2019-06-17     南   \n",
       "NaN  1室2厅1厨1卫  暂无数据  暂无数据  商业办公类  低楼层(共19层)   NaN     382  2019-08-05  东 东南   \n",
       "NaN  2室1厅1厨1卫    平层  暂无数据   普通住宅   高楼层(共6层)   NaN     315  2019-02-25     南   \n",
       "NaN  1室0厅0厨1卫    平层  暂无数据   普通住宅   高楼层(共6层)   NaN     152  2019-08-25     南   \n",
       "NaN  1室1厅1厨1卫  暂无数据  暂无数据   普通住宅   中楼层(共6层)   NaN     205  2019-08-15   南 北   \n",
       "NaN  1室1厅1厨1卫    平层  暂无数据   普通住宅   中楼层(共6层)   NaN     176  2019-08-03     南   \n",
       "NaN  2室1厅1厨1卫  暂无数据  暂无数据   普通住宅   中楼层(共6层)   NaN     248  2019-08-20    西南   \n",
       "\n",
       "     来源                       标题   梯户比例   楼型 浏览（次）  状态 电梯  \\\n",
       "NaN NaN  中凯城市之光(静安) 1室0厅 30.72平米   一梯五户  NaN   149 NaN  无   \n",
       "NaN NaN        康平小区 1室1厅 47.49平米   一梯五户  NaN   785 NaN  有   \n",
       "NaN NaN           万荣小区 1室1厅 44平米   一梯四户  NaN  1345 NaN  无   \n",
       "NaN NaN        彭新小区 2室0厅 50.24平米   一梯四户  NaN  3471 NaN  无   \n",
       "NaN NaN      阳曲路75弄 1室1厅 41.77平米   一梯四户  NaN  3321 NaN  无   \n",
       "NaN NaN     岭南路270弄 1室1厅 52.39平米   一梯三户  NaN  3462 NaN  无   \n",
       "NaN NaN         内外联公寓 3室2厅 152平米   两梯八户  NaN  1313 NaN  有   \n",
       "NaN NaN        星城花苑 2室1厅 67.26平米   两梯八户  NaN  3218 NaN  有   \n",
       "NaN NaN     场中路2401弄 1室1厅 37.8平米   一梯四户  NaN  1406 NaN  无   \n",
       "NaN NaN   中海万锦城(四期) 1室2厅 68.17平米  四梯十八户  NaN   929 NaN  有   \n",
       "NaN NaN         保德公寓 2室1厅 66.8平米   一梯三户  NaN  3736 NaN  无   \n",
       "NaN NaN         彭新小区 1室0厅 32.6平米   一梯四户  NaN   319 NaN  无   \n",
       "NaN NaN        恒安小区 1室1厅 43.75平米   一梯三户  NaN   421 NaN  无   \n",
       "NaN NaN        银都一村 1室1厅 37.47平米   一梯四户  NaN  1125 NaN  无   \n",
       "NaN NaN        康泉小区 2室1厅 51.07平米   一梯四户  NaN   460 NaN  无   \n",
       "\n",
       "                                                    网址  装修  调价(次)  \\\n",
       "NaN  https://sh.lianjia.com/chengjiao/107101180471....  其他    1.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101602927....  简装    0.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101525418....  精装    1.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101328353....  毛坯    1.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101024782....  简装    1.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107100709331....  简装    1.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107002175707....  简装    1.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101256568....  简装    1.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101438976....  简装    1.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101612401....  简装    1.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101054821....  精装    0.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101681031....  简装    0.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101643730....  简装    0.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101604638....  精装    1.0   \n",
       "NaN  https://sh.lianjia.com/chengjiao/107101663637....  精装    1.0   \n",
       "\n",
       "             链家编号  \n",
       "NaN  107101180471  \n",
       "NaN  107101602927  \n",
       "NaN  107101525418  \n",
       "NaN  107101328353  \n",
       "NaN  107101024782  \n",
       "NaN  107100709331  \n",
       "NaN  107002175707  \n",
       "NaN  107101256568  \n",
       "NaN  107101438976  \n",
       "NaN  107101612401  \n",
       "NaN  107101054821  \n",
       "NaN  107101681031  \n",
       "NaN  107101643730  \n",
       "NaN  107101604638  \n",
       "NaN  107101663637  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df1.loc[df1['成交价(元/平)']<47000]\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>小区</th>\n",
       "      <th>成交时间</th>\n",
       "      <th>成交价(元/平)</th>\n",
       "      <th>售价(万)</th>\n",
       "      <th>户型</th>\n",
       "      <th>建筑面积</th>\n",
       "      <th>建成时间</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>链家编号</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>107101604638</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2019-09-06</td>\n",
       "      <td>45904.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>37.47</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107101584415</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2019-07-30</td>\n",
       "      <td>44036.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>1室1厅0厨1卫</td>\n",
       "      <td>37.47</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107101383475</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2019-06-30</td>\n",
       "      <td>44303.0</td>\n",
       "      <td>215.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>48.53</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107101353702</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2019-06-16</td>\n",
       "      <td>45229.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>34.16</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107101308988</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2019-05-14</td>\n",
       "      <td>47182.0</td>\n",
       "      <td>154.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>32.64</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107101229060</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2019-04-24</td>\n",
       "      <td>41408.0</td>\n",
       "      <td>153.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>36.95</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107100828230</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2019-04-18</td>\n",
       "      <td>41679.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>34.79</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107001454969</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-12-21</td>\n",
       "      <td>40961.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>34.79</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107100117446</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-12-15</td>\n",
       "      <td>46297.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>49.68</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107100594380</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-11-30</td>\n",
       "      <td>41367.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>37.47</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107100769638</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-11-28</td>\n",
       "      <td>41679.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>34.79</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107100344870</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-11-21</td>\n",
       "      <td>46297.0</td>\n",
       "      <td>230.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>49.68</td>\n",
       "      <td>1997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107001924907</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-09-03</td>\n",
       "      <td>40388.0</td>\n",
       "      <td>196.0</td>\n",
       "      <td>2室0厅1厨1卫</td>\n",
       "      <td>48.53</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107100113089</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-06-23</td>\n",
       "      <td>49939.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>32.64</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107001816097</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-05-26</td>\n",
       "      <td>47796.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>35.15</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107100272675</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-05-15</td>\n",
       "      <td>47140.0</td>\n",
       "      <td>164.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>34.79</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107100131368</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-05-14</td>\n",
       "      <td>46705.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>37.47</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107100081142</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-03-14</td>\n",
       "      <td>47606.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>34.24</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107002280661</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-01-30</td>\n",
       "      <td>45269.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>34.24</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107002306375</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2018-01-20</td>\n",
       "      <td>52766.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>35.25</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107002268845</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2017-12-10</td>\n",
       "      <td>52133.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>2室0厅1厨1卫</td>\n",
       "      <td>48.53</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107002156477</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2017-10-29</td>\n",
       "      <td>52709.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>37.47</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107001947285</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2017-07-15</td>\n",
       "      <td>55311.0</td>\n",
       "      <td>194.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>35.06</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107001075579</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2017-04-17</td>\n",
       "      <td>51775.0</td>\n",
       "      <td>194.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>37.47</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107001158345</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2017-03-29</td>\n",
       "      <td>50708.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>37.47</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107000172909</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2017-03-14</td>\n",
       "      <td>48374.0</td>\n",
       "      <td>238.0</td>\n",
       "      <td>2室1厅1厨1卫</td>\n",
       "      <td>49.20</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107001283637</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2017-03-03</td>\n",
       "      <td>46096.0</td>\n",
       "      <td>229.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>49.68</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107001622685</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2017-01-10</td>\n",
       "      <td>52838.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>30.66</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010103672</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2016-10-22</td>\n",
       "      <td>48606.0</td>\n",
       "      <td>258.0</td>\n",
       "      <td>2室0厅1厨1卫</td>\n",
       "      <td>53.08</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010097348</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2016-09-11</td>\n",
       "      <td>43921.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>50.09</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010092399</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2016-08-27</td>\n",
       "      <td>42220.0</td>\n",
       "      <td>156.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>36.95</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010082050</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2016-07-26</td>\n",
       "      <td>42349.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>34.24</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010070310</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2016-03-26</td>\n",
       "      <td>41054.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>32.64</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010069762</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2016-03-26</td>\n",
       "      <td>39829.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>32.64</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010061960</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2016-02-27</td>\n",
       "      <td>34493.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>34.79</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010060979</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2016-02-19</td>\n",
       "      <td>30234.0</td>\n",
       "      <td>106.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>35.06</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010060525</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2016-02-18</td>\n",
       "      <td>32495.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>34.16</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010058352</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2016-01-31</td>\n",
       "      <td>29215.0</td>\n",
       "      <td>144.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>49.29</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010034863</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2015-11-15</td>\n",
       "      <td>26170.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>2室0厅1厨1卫</td>\n",
       "      <td>48.53</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010033111</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2015-10-30</td>\n",
       "      <td>27882.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>1室1厅1厨1卫</td>\n",
       "      <td>34.79</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107010028093</th>\n",
       "      <td>银都一村</td>\n",
       "      <td>2015-10-11</td>\n",
       "      <td>25870.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>1室0厅1厨1卫</td>\n",
       "      <td>34.79</td>\n",
       "      <td>1995</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                小区        成交时间  成交价(元/平)  售价(万)        户型   建筑面积  建成时间\n",
       "链家编号                                                                  \n",
       "107101604638  银都一村  2019-09-06   45904.0  172.0  1室1厅1厨1卫  37.47  1995\n",
       "107101584415  银都一村  2019-07-30   44036.0  165.0  1室1厅0厨1卫  37.47  1995\n",
       "107101383475  银都一村  2019-06-30   44303.0  215.0  1室1厅1厨1卫  48.53  1995\n",
       "107101353702  银都一村  2019-06-16   45229.0  155.0  1室0厅1厨1卫  34.16  1995\n",
       "107101308988  银都一村  2019-05-14   47182.0  154.0  1室0厅1厨1卫  32.64  1995\n",
       "107101229060  银都一村  2019-04-24   41408.0  153.0  1室1厅1厨1卫  36.95  1995\n",
       "107100828230  银都一村  2019-04-18   41679.0  145.0  1室1厅1厨1卫  34.79  1995\n",
       "107001454969  银都一村  2018-12-21   40961.0  143.0  1室0厅1厨1卫  34.79  1995\n",
       "107100117446  银都一村  2018-12-15   46297.0  230.0  1室1厅1厨1卫  49.68  1995\n",
       "107100594380  银都一村  2018-11-30   41367.0  155.0  1室1厅1厨1卫  37.47  1995\n",
       "107100769638  银都一村  2018-11-28   41679.0  145.0  1室1厅1厨1卫  34.79  1995\n",
       "107100344870  银都一村  2018-11-21   46297.0  230.0  1室1厅1厨1卫  49.68  1997\n",
       "107001924907  银都一村  2018-09-03   40388.0  196.0  2室0厅1厨1卫  48.53  1995\n",
       "107100113089  银都一村  2018-06-23   49939.0  163.0  1室1厅1厨1卫  32.64  1995\n",
       "107001816097  银都一村  2018-05-26   47796.0  168.0  1室1厅1厨1卫  35.15  1995\n",
       "107100272675  银都一村  2018-05-15   47140.0  164.0  1室1厅1厨1卫  34.79  1995\n",
       "107100131368  银都一村  2018-05-14   46705.0  175.0  1室0厅1厨1卫  37.47  1995\n",
       "107100081142  银都一村  2018-03-14   47606.0  163.0  1室1厅1厨1卫  34.24  1995\n",
       "107002280661  银都一村  2018-01-30   45269.0  155.0  1室1厅1厨1卫  34.24  1995\n",
       "107002306375  银都一村  2018-01-20   52766.0  186.0  1室1厅1厨1卫  35.25  1995\n",
       "107002268845  银都一村  2017-12-10   52133.0  253.0  2室0厅1厨1卫  48.53  1995\n",
       "107002156477  银都一村  2017-10-29   52709.0  198.0  1室1厅1厨1卫  37.47  1995\n",
       "107001947285  银都一村  2017-07-15   55311.0  194.0  1室0厅1厨1卫  35.06  1995\n",
       "107001075579  银都一村  2017-04-17   51775.0  194.0  1室0厅1厨1卫  37.47  1995\n",
       "107001158345  银都一村  2017-03-29   50708.0  190.0  1室0厅1厨1卫  37.47  1995\n",
       "107000172909  银都一村  2017-03-14   48374.0  238.0  2室1厅1厨1卫  49.20  1995\n",
       "107001283637  银都一村  2017-03-03   46096.0  229.0  1室1厅1厨1卫  49.68  1995\n",
       "107001622685  银都一村  2017-01-10   52838.0  162.0  1室0厅1厨1卫  30.66  1995\n",
       "107010103672  银都一村  2016-10-22   48606.0  258.0  2室0厅1厨1卫  53.08  1995\n",
       "107010097348  银都一村  2016-09-11   43921.0  220.0  1室1厅1厨1卫  50.09  1995\n",
       "107010092399  银都一村  2016-08-27   42220.0  156.0  1室0厅1厨1卫  36.95  1995\n",
       "107010082050  银都一村  2016-07-26   42349.0  145.0  1室0厅1厨1卫  34.24  1995\n",
       "107010070310  银都一村  2016-03-26   41054.0  134.0  1室0厅1厨1卫  32.64  1995\n",
       "107010069762  银都一村  2016-03-26   39829.0  130.0  1室0厅1厨1卫  32.64  1995\n",
       "107010061960  银都一村  2016-02-27   34493.0  120.0  1室0厅1厨1卫  34.79  1995\n",
       "107010060979  银都一村  2016-02-19   30234.0  106.0  1室1厅1厨1卫  35.06  1995\n",
       "107010060525  银都一村  2016-02-18   32495.0  111.0  1室1厅1厨1卫  34.16  1995\n",
       "107010058352  银都一村  2016-01-31   29215.0  144.0  1室1厅1厨1卫  49.29  1995\n",
       "107010034863  银都一村  2015-11-15   26170.0  127.0  2室0厅1厨1卫  48.53  1995\n",
       "107010033111  银都一村  2015-10-30   27882.0   97.0  1室1厅1厨1卫  34.79  1995\n",
       "107010028093  银都一村  2015-10-11   25870.0   90.0  1室0厅1厨1卫  34.79  1995"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from common import plot_df\n",
    "xiaoqu=df.loc[df['小区']=='星纪花苑']\n",
    "xiaoqu=df.loc[df['小区']=='奥克斯缔逸城']\n",
    "xiaoqu=df.loc[df['小区']=='康平小区']\n",
    "xiaoqu=df.loc[df['小区']=='银都一村']\n",
    "\n",
    "xiaoqu.index = xiaoqu['链家编号']\n",
    "xiaoqu = xiaoqu.sort_values('成交时间', ascending = False)\n",
    "xiaoqu.loc[:,['小区','成交时间','成交价(元/平)','售价(万)','户型','建筑面积','建成时间']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://sh.lianjia.com/chengjiao/107101694476.html'"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "xiaoqu.iloc[0]['网址']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "链家编号\n",
       "103104140710    70年\n",
       "103102732155    70年\n",
       "103104627237    70年\n",
       "103102599864    70年\n",
       "103103514236    70年\n",
       "103103370737    70年\n",
       "103104468254    70年\n",
       "103104256753    70年\n",
       "103103144273    70年\n",
       "103103500001    70年\n",
       "103103744323    70年\n",
       "103104029321    70年\n",
       "103103774118    70年\n",
       "103103541108    70年\n",
       "103103815194    70年\n",
       "103102707514    70年\n",
       "103103557345    70年\n",
       "103103088383    70年\n",
       "103103115329    70年\n",
       "103102931326    70年\n",
       "103102785089    70年\n",
       "103102980744    70年\n",
       "103102928491    70年\n",
       "103102893100    70年\n",
       "103102252743    70年\n",
       "103102406223    70年\n",
       "103102104200    70年\n",
       "103102321554    70年\n",
       "103102182779    70年\n",
       "103101826200    70年\n",
       "103101679961    70年\n",
       "103101642055    70年\n",
       "103101845882    70年\n",
       "103101743909    70年\n",
       "103101640113    70年\n",
       "103101788769    70年\n",
       "103101078572    70年\n",
       "103101517913    70年\n",
       "103101293725    70年\n",
       "103101171628    70年\n",
       "103101269129    70年\n",
       "103101016242    70年\n",
       "103101102293    70年\n",
       "103101094558    70年\n",
       "103101034926    70年\n",
       "103100953480    70年\n",
       "103100984105    70年\n",
       "103100747723    70年\n",
       "103100721176    70年\n",
       "103100614491    70年\n",
       "103100608089    70年\n",
       "103100585194    70年\n",
       "103100556605    70年\n",
       "Name: 土地年限, dtype: object"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "xiaoqu['土地年限']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
